SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO

CREATE PROCEDURE [dbo].[GetMemberById]
@MemberId int
AS
SELECT TOP 1 * FROM vMember WHERE Id = @MemberId;
GO
